This file helps you track office assets such as furniture, equipment, or any other depreciable item. The file includes fields to input the serial number and purchase date of the asset.
How to use this solution
You can print an inventory report that you can use to complete your taxes.
How to customize this solution
The Item, Location, Assigned To, and Purchased From fields use value lists based on the their own contents. This means that every time you add a new value in any o
f those fields, the value is added to the pop-up list for the field, making it easier to enter that value in the future.
The Category pop-up menu is based on a pre-defined value list. To edit the value list, select the Category field in the Form View layout in Layout mode. Choose Field Format
from the Format menu. In the pop-up menu of value lists, choose Define Value List
, and edit the list of categories.
Assigned ToB
Date PlacedB
Purchased FromB
Dep LifeB
Book ValueB
& <> 0
Remaining LifeB
& * 365 -
b)) / 365 > 0
& * 365 -
b)) / 365
Total Book ValB
DepreciationB
-A Total DepB
PictureB
Date AssignedB
InfoB
Created ByB
A List View
Inventory Report
Information
Report Menu
Depreciation Report
@4A Form View
A List ViewB
Inventory ReportB
Your Own
ButtonW
Your Own
ButtonX
RecordY
Delete
RecordZ
Record[
Reports\
View As
List]
View As
Form^
Close_
Info`
Locationa
Assigned Tob
Serial No.c
Modeld
Iteme
Category
Your Own
ButtonW
Your Own
ButtonX
RecordY
Delete
RecordZ
Record[
Reports\
View As
List]
View As
Form^
Close_
Info`
Locationa
Assigned Tob
Serial No.c
Modeld
Iteme
Category
f*Click to see more information for an Asset
InformationB
Your Own
Buttonw
Reportsx
View As
Listy
View As
Formz
Close{
Info|
Page ##~
Asset Inventory Report
Category
Date Placed
Location
Serial Number
Assigned
Model
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO%Information about the Assets solutionP
Info for this Solution
rmation about the Assets solutionP
Info for this Solution
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
InfoG
Your Own
ReportH
Your Own
ReportI
Depreciation ReportJ
Inventory ReportK>Click on any of these buttons to preview the respective reportL
Select a report
ReportI
Depreciation ReportJ
Inventory ReportK>Click on any of these buttons to preview the respective reportL
Select a report
Depreciation ReportB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
A Form ViewB
Your Own
Button
Reports
View As
View As
Close
Deprec.
Grand Totals:
J Rem. Life
K Dep.
Value
Page ##
Asset Depreciation Report
Serial Number
Model
Posture SpecialC
Office ChairE
Office FurnitureG
03/01/94X
04/30/95Y
12/04/95a
3343b
M-S 442c
Sonia Longd
03/01/94e
ABC Chair Companyf
153.89i
2.23835616438356l
121.11n
05/13/94
Posture SpecialC
Office ChairE
Office FurnitureG
06/03/94X
04/30/95Y
12/04/95a
3344b
M-S 723c
Darren Smithd
06/03/94e
ABC Chair Companyf
171.59i
2.4958904109589l
103.41o
06/03/94
486/50C
ComputerE
Office FurnitureG
150000H
03/22/94X
04/30/95Y
12/04/95a
3939382b
M-S 723c
Darren Smithd
03/26/94e
The Computers Shopf
98876.71i
3.2958904109589l
51123.29o
03/26/94
150550
49201.03
Your Own
Buttonx
Your Own
Buttony
Recordz
Delete
Record{
Record|
Reports}
View As
List~
View As
Close
Depreciation
Depreciation
Book Value
Remaining Life (years)
Depreciation Life (years)
Date Placed in Service
Date Purchased
Purchased From
Acquisition
Location
Assigned To
Assignment
Picture
Category
Model
Serial No.
Asset ID
Asset
Enter data for Assets
Sort by Category
Sort by Assigned To
Inventory Report
Depreciation Report
Open Script
Sort by Category
Inventory Report
Sort by Assigned To
Depreciation Report
Open Script
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
CWF_Mono
) = 400
Cancel
Cancel
No records match this request.E)
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
(LIST
LISTA0Office Furniture
Computers
Telephones
Vehicles
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
(LIST
VDEFA(
Category ListB
Assigned To ListC Item ListD
Location ListE
Purchased From List
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
3333ff
333333
wwwwww
UUUUUU
DDDDDD
""""""
wwwwww
ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
*00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
UUUUUU
wwwwww
) = 400
Cancel
You did not enter any find criteria; all records will be displayed.C)
(.txt)